Tabela PhOrderCard

Definicja tabeli PhOrderCard

Name

PhOrderCard

Code

PhOrderCard

Comment

Karty asortymentowe


Lista kolumn tabeli PhOrderCard

Name

Code

OrderCardID

OrderCardID

DocNo

DocNo

StatusID

StatusID

TypeID

TypeID

GeneratedDT

GeneratedDT

AcceptedDT

AcceptedDT

AcceptedPersonID

AcceptedPersonID

Description

Description

Active

Active

StID

StID


Kolumna OrderCardID tabeli PhOrderCard

Definicja kolumny OrderCardID tabeli PhOrderCard

Name

OrderCardID

Code

OrderCardID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID karty asortymentowej


Kolumna DocNo tabeli PhOrderCard

Definicja kolumny DocNo tabeli PhOrderCard

Name

DocNo

Code

DocNo

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

Numer karty asortymentowej


Kolumna StatusID tabeli PhOrderCard

Definicja kolumny StatusID tabeli PhOrderCard

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Status


Kolumna TypeID tabeli PhOrderCard

Definicja kolumny TypeID tabeli PhOrderCard

Name

TypeID

Code

TypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Type


Kolumna GeneratedDT tabeli PhOrderCard

Definicja kolumny GeneratedDT tabeli PhOrderCard

Name

GeneratedDT

Code

GeneratedDT

Data Type

DATE

Mandatory

No

Comment

Data generowania


Kolumna AcceptedDT tabeli PhOrderCard

Definicja kolumny AcceptedDT tabeli PhOrderCard

Name

AcceptedDT

Code

AcceptedDT

Data Type

DATE

Mandatory

No

Comment

Data akceptacji


Kolumna AcceptedPersonID tabeli PhOrderCard

Definicja kolumny AcceptedPersonID tabeli PhOrderCard

Name

AcceptedPersonID

Code

AcceptedPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

Osoba akceptujaca


Kolumna Description tabeli PhOrderCard

Definicja kolumny Description tabeli PhOrderCard

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Opis


Kolumna Active tabeli PhOrderCard

Definicja kolumny Active tabeli PhOrderCard

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Czy aktywna


Kolumna StID tabeli PhOrderCard

Definicja kolumny StID tabeli PhOrderCard

Name

StID

Code

StID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Lista kluczy tabeli PhOrderCard

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhOrderCard

Definicja klucza Identifier_1 tabeli PhOrderCard

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment